USE Liberty
GO
---------------------------------------------------------------------------------------------------
----TypesOfMilitaryBranch (TypesOfMilitaryBranch)
---------------------------------------------------------------------------------------------------
SET NOCOUNT OFF
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET QUOTED_IDENTIFIER ON
SET NUMERIC_ROUNDABORT OFF
GO

PRINT 'Creating Table TypesOfMilitaryBranch...'
GO

IF OBJECT_ID( 'TypesOfMilitaryBranch' ) IS NULL
BEGIN
	CREATE TABLE dbo.TypesOfMilitaryBranch
	(OID					bigint		IDENTITY(1, 1)	NOT NULL
	,Version				rowversion
	,Branch					varchar(15)					NOT NULL
	,Active					tinyint						NOT NULL 
		CONSTRAINT DFLT_TypesOfMilitaryBranch_Active DEFAULT (1)
	,DisplayOrder		smallint						NOT NULL 
	    CONSTRAINT DFLT_TypesOfMilitaryBranch_DisplayOrder DEFAULT (1)
	,CreatedDate			datetime					NOT NULL
		CONSTRAINT DFLT_TypesOfMilitaryBranch_CreatedDate DEFAULT GETDATE()

	,CONSTRAINT PK_TypesOfMilitaryBranch PRIMARY KEY CLUSTERED( OID ) --ON PRIMARY

	)

	PRINT 'Table TypesOfMilitaryBranch has been created successfully.'

END
ELSE 
BEGIN
    PRINT 'Table TypesOfMilitaryBranch already exists.'
END

GO

--DROP TABLE dbo.TypesOfMilitaryBranch
